Tabela VaccineOrderItem

Definicja tabeli VaccineOrderItem

Name

VaccineOrderItem

Code

VaccineOrderItem

Comment

Pojedyncze szczepienie w ramach zlecenia


Lista kolumn tabeli VaccineOrderItem

Name

Code

VaccineOrderItemID

VaccineOrderItemID

VaccineID

VaccineID

VaccineOrderID

VaccineOrderID

StockItemQuantityIndexID

StockItemQuantityIndexID

RiskGroupID

RiskGroupID

VaccinationReasonID

VaccinationReasonID

VaccineNo

VaccineNo

AssociatedVaccine

AssociatedVaccine

DoseNumber

DoseNumber

VaccineKind

VaccineKind

AdministrationMethodID

AdministrationMethodID

VaccineComment

VaccineComment

RemindDose

RemindDose

DrugName

DrugName

DrugNo

DrugNo

DrugDBTypeID

DrugDBTypeID

SeriesNo

SeriesNo

DrugsQuantity

DrugsQuantity

DrugDose

DrugDose

insertingPerson

insertingPerson

insertDT

insertDT


Kolumna VaccineOrderItemID tabeli VaccineOrderItem

Definicja kolumny VaccineOrderItemID tabeli VaccineOrderItem

Name

VaccineOrderItemID

Code

VaccineOrderItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna VaccineID tabeli VaccineOrderItem

Definicja kolumny VaccineID tabeli VaccineOrderItem

Name

VaccineID

Code

VaccineID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna VaccineOrderID tabeli VaccineOrderItem

Definicja kolumny VaccineOrderID tabeli VaccineOrderItem

Name

VaccineOrderID

Code

VaccineOrderID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID zlecenia


Kolumna StockItemQuantityIndexID tabeli VaccineOrderItem

Definicja kolumny StockItemQuantityIndexID tabeli VaccineOrderItem

Name

StockItemQuantityIndexID

Code

StockItemQuantityIndexID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RiskGroupID tabeli VaccineOrderItem

Definicja kolumny RiskGroupID tabeli VaccineOrderItem

Name

RiskGroupID

Code

RiskGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

Grupa ryzyka


Kolumna VaccinationReasonID tabeli VaccineOrderItem

Definicja kolumny VaccinationReasonID tabeli VaccineOrderItem

Name

VaccinationReasonID

Code

VaccinationReasonID

Data Type

NUMBER(10)

Mandatory

No

Comment

Powód szczepienia


Kolumna VaccineNo tabeli VaccineOrderItem

Definicja kolumny VaccineNo tabeli VaccineOrderItem

Name

VaccineNo

Code

VaccineNo

Data Type

NUMBER(5)

Mandatory

Yes

Comment

numer szczepionki


Kolumna AssociatedVaccine tabeli VaccineOrderItem

Definicja kolumny AssociatedVaccine tabeli VaccineOrderItem

Name

AssociatedVaccine

Code

AssociatedVaccine

Data Type

NUMBER(1)

Mandatory

Yes

Comment

szczepionka skojarzona


Kolumna DoseNumber tabeli VaccineOrderItem

Definicja kolumny DoseNumber tabeli VaccineOrderItem

Name

DoseNumber

Code

DoseNumber

Data Type

VARCHAR2(16)

Mandatory

No

Comment

numer dawki


Kolumna VaccineKind tabeli VaccineOrderItem

Definicja kolumny VaccineKind tabeli VaccineOrderItem

Name

VaccineKind

Code

VaccineKind

Data Type

VARCHAR2(24)

Mandatory

No

Comment

rodzaj szczepionki


Kolumna AdministrationMethodID tabeli VaccineOrderItem

Definicja kolumny AdministrationMethodID tabeli VaccineOrderItem

Name

AdministrationMethodID

Code

AdministrationMethodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VaccineComment tabeli VaccineOrderItem

Definicja kolumny VaccineComment tabeli VaccineOrderItem

Name

VaccineComment

Code

VaccineComment

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz


Kolumna RemindDose tabeli VaccineOrderItem

Definicja kolumny RemindDose tabeli VaccineOrderItem

Name

RemindDose

Code

RemindDose

Data Type

NUMBER(1)

Mandatory

Yes

Comment

dawka przypominajaca


Kolumna DrugName tabeli VaccineOrderItem

Definicja kolumny DrugName tabeli VaccineOrderItem

Name

DrugName

Code

DrugName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

nazwa leku


Kolumna DrugNo tabeli VaccineOrderItem

Definicja kolumny DrugNo tabeli VaccineOrderItem

Name

DrugNo

Code

DrugNo

Data Type

VARCHAR2(16)

Mandatory

No

Comment

id leku


Kolumna DrugDBTypeID tabeli VaccineOrderItem

Definicja kolumny DrugDBTypeID tabeli VaccineOrderItem

Name

DrugDBTypeID

Code

DrugDBTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

rodzaj bazy leków


Kolumna SeriesNo tabeli VaccineOrderItem

Definicja kolumny SeriesNo tabeli VaccineOrderItem

Name

SeriesNo

Code

SeriesNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

numer serii


Kolumna DrugsQuantity tabeli VaccineOrderItem

Definicja kolumny DrugsQuantity tabeli VaccineOrderItem

Name

DrugsQuantity

Code

DrugsQuantity

Data Type

NUMBER(10)

Mandatory

No

Comment

ilosc leku


Kolumna DrugDose tabeli VaccineOrderItem

Definicja kolumny DrugDose tabeli VaccineOrderItem

Name

DrugDose

Code

DrugDose

Data Type

NUMBER(10,2)

Mandatory

No

Comment

dawka


Kolumna insertingPerson tabeli VaccineOrderItem

Definicja kolumny insertingPerson tabeli VaccineOrderItem

Name

insertingPerson

Code

insertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna insertDT tabeli VaccineOrderItem

Definicja kolumny insertDT tabeli VaccineOrderItem

Name

insertDT

Code

insertDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli VaccineOrderItem

Name

Code

Primary

PK_VaccineOrderItem

PK_VaccineOrderItem

X


Klucz PK_VaccineOrderItem tabeli VaccineOrderItem

Definicja klucza PK_VaccineOrderItem tabeli VaccineOrderItem

Name

PK_VaccineOrderItem

Code

PK_VaccineOrderItem

Primary

Yes

Comment